Postgres docs and skills. Helps AI coding tools generate better PostgreSQL code.
@Tiger Data
AI-optimized PostgreSQL expertise for coding assistants. pg-aiguide helps AI coding tools write dramatically better PostgreSQL code.
It provides:
- Semantic search across the official PostgreSQL manual (version-aware)
- AI-optimized “skills” available through MCP tools — curated, opinionated Postgres best practices used automatically by AI agents
- Extension ecosystem docs, starting with TimescaleDB, with more coming soon
Overview
what is pg-aiguide?
pg-aiguide is an AI-optimized tool designed to enhance the capabilities of coding assistants by providing deep PostgreSQL expertise, ensuring that the generated code is up-to-date and follows best practices.
how to use pg-aiguide?
To use pg-aiguide, you can access it via the public MCP server at https://mcp.tigerdata.com/docs. Once installed, you can prompt it with questions about PostgreSQL or request schema designs.
key features of pg-aiguide?
- Semantic search across the official PostgreSQL manual, tailored to specific versions.
- AI-optimized skills that provide curated best practices for PostgreSQL.
- Support for extension ecosystem documentation, starting with TimescaleDB.
use cases of pg-aiguide?
- Assisting AI coding tools in generating accurate PostgreSQL code.
- Providing guidance on schema design and indexing strategies.
- Enhancing the understanding of modern PostgreSQL features for developers.
FAQ from pg-aiguide?
- Can pg-aiguide help with all PostgreSQL versions?
Yes! pg-aiguide is designed to provide version-aware support for PostgreSQL.
- Is pg-aiguide free to use?
Yes! pg-aiguide is available for free through the public MCP server.
- How does pg-aiguide ensure best practices?
pg-aiguide uses curated skills that reflect proven PostgreSQL best practices, ensuring high-quality code generation.
Server Config
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}